/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package pkgUtil.pkgJavaDB;

/**
 *
 * @author Armando
 */
public class ConstantsJavaDB {
     public static String CLASS_DRIVER_JAVADB = "org.apache.derby.jdbc.EmbeddedDriver";
     public static String NAME_TABLA_CONTEXTO = "CONTEXTO";
     public static String SCRIPT_CREATE_TABLE_CONTEXTO = "CREATE table APP.CONTEXTO ("
                                                            + "ID          INTEGER NOT NULL"
                                                            + "            PRIMARY KEY GENERATED ALWAYS AS IDENTITY"
                                                            + "            (START WITH 1, INCREMENT BY 1),"
                                                            + "PAIS              VARCHAR(30),"
                                                            + "IDIOMA            VARCHAR(30),"
                                                            + "SEPARADOR_MILES   VARCHAR(1),"
                                                            + "SEPARADOR_DECIMAL VARCHAR(1))";
    public static String QUERY_SEL_TABLE_CONTEXTO = "SELECT PAIS,IDIOMA,SEPARADOR_MILES,SEPARADOR_DECIMAL FROM CONTEXTO"; 
    public static String QUERY_INSERT_TABLE_CONTEXTO = "INSERT INTO CONTEXTO (PAIS,IDIOMA,SEPARADOR_MILES,SEPARADOR_DECIMAL) VALUES (?,?,?,?)"; 
    public static String QUERY_UPDATE_TABLE_CONTEXTO = "UPDATE CONTEXTO SET PAIS=?,IDIOMA=?,SEPARADOR_MILES=?,SEPARADOR_DECIMAL=? WHERE ID=?"; 
    public static int    ID_REGISTER_TABLE_CONTEXTO = 1; 
   

}
